package com.ship.dispatch.mapper.fob;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ship.dispatch.bean.fob.SpFobSubleaseRentComplete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;

public interface SpFobSubleaseRentCompleteMapper extends BaseMapper<SpFobSubleaseRentComplete> {
    @Select("select SUM(balance) as balance from sp_fob_sublease_rent_complete where procee_instance_id=#{processInstanceId}")
    BigDecimal findBalances(@Param("processInstanceId") String processInstanceId);
}
